CREATE VIEW [dbo].[vGiftSummary]
AS
    SELECT ID,
           OriginalTransaction,
           MAX(TransactionDate)  TransactionDate,
           SUM(Amount) Gift
    FROM vGift
    GROUP BY  OriginalTransaction,ID

GO
GRANT REFERENCES ON  [dbo].[vGiftSummary] TO [IMIS]
GRANT SELECT ON  [dbo].[vGiftSummary] TO [IMIS]
GRANT INSERT ON  [dbo].[vGiftSummary] TO [IMIS]
GRANT DELETE ON  [dbo].[vGiftSummary] TO [IMIS]
GRANT UPDATE ON  [dbo].[vGiftSummary] TO [IMIS]
GO